﻿

if not Exists(select * from sysobjects where name = 'NewsLetterSMTPServer' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterSMTPServer (
		Id int identity(1,1) not null,
		Name varchar(50) not null,
		HostName varchar(100) null,
		Port int null,
		Timeout int null,
		UseSSL bit null,
		Login varchar(100),
		Password varchar(512), /* A Encrypter */
		DKIMPrivateKey varchar(2048),
		DKIMSelector varchar(50)
	)

	alter table dbo.NewsLetterSMTPServer add constraint PK_NewsLetterSMTPServer_Id primary key (Id)

End